﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Hp.Vertica.Migration.SqlServer
{
    public class SystemTableCollection : TableCollection<SystemTable>
    {
        protected override string QueryText
        {
            get { return "SELECT s.name AS [SchemaName], t.name, t.create_date,t.modify_date FROM sys.all_objects t JOIN sys.schemas s ON t.schema_id = s.schema_id WHERE type_desc='SYSTEM_TABLE'"; }
        }

        public SystemTableCollection(SqlServer.Database database) : base(database) { }
    }
}
